﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Artists.aspx.vb" Inherits="_3dBuzz.Artists" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <p>
        Artists</p>
    <p>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource1" DataKeyNames="ID" AllowSorting="True">
            <Columns>
                <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" >
                <HeaderStyle CssClass="columnhead" />
                </asp:BoundField>
                <asp:BoundField DataField="Firstname" HeaderText="Firstname" 
                    SortExpression="Firstname" >
                <HeaderStyle CssClass="columnhead" />
                </asp:BoundField>
                <asp:BoundField DataField="Surname" HeaderText="Surname" 
                    SortExpression="Surname" >
                <HeaderStyle CssClass="columnhead" />
                </asp:BoundField>
                <asp:BoundField DataField="Nickname" HeaderText="Display Name" 
                    SortExpression="Nickname" >
                <HeaderStyle CssClass="columnhead" />
                </asp:BoundField>
                <asp:BoundField DataField="Town" HeaderText="Town" SortExpression="Town" >
                <HeaderStyle CssClass="columnhead" />
                </asp:BoundField>
                <asp:BoundField DataField="County" HeaderText="County" 
                    SortExpression="County" >
                                  <HeaderStyle CssClass="columnhead" />
                </asp:BoundField>
                                  <asp:BoundField DataField="Country" HeaderText="Country" 
                    SortExpression="Country" >
                <HeaderStyle CssClass="columnhead" />
                </asp:BoundField>
                <asp:BoundField DataField="Companyname" HeaderText="Company " 
                    SortExpression="Companyname" >
                <HeaderStyle CssClass="columnhead" />
                </asp:BoundField>
                <asp:HyperLinkField DataNavigateUrlFields="Email" DataTextField="Email" 
                    DataTextFormatString="&lt;a href=mailto:{0}&gt;{0}&lt;/a&gt;" 
                    HeaderText="Email" SortExpression="Email" >
                <HeaderStyle CssClass="columnhead" />
                </asp:HyperLinkField>
                <asp:HyperLinkField DataNavigateUrlFields="WebURL" 
                    DataNavigateUrlFormatString="{0}" DataTextField="WebURL" HeaderText="Web Site" 
                    SortExpression="WebURL" >
                <HeaderStyle CssClass="columnhead" />
                </asp:HyperLinkField>
                <asp:HyperLinkField DataNavigateUrlFields="ID" 
                    DataNavigateUrlFormatString="ArtVideoList.aspx?ArtistId={0}" 
                    HeaderText="View Showreels" Text="Select" >
                <HeaderStyle CssClass="columnhead" />
                </asp:HyperLinkField>
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:3dBuzzDatabase %>" 
            ProviderName="<%$ ConnectionStrings:3dBuzzDatabase.ProviderName %>" 
            
            
            SelectCommand="SELECT [Title], [Firstname], [Surname], [Nickname], [Addr1], [Addr2], [Town], [County], [Country],[ID], [Email], [WebURL], [Companyname] FROM [Artists]">
        </asp:SqlDataSource>
    </p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
</asp:Content>
